-- Server version: 5.0.51
-- PHP Version: 5.2.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `ir33`
--

-- --------------------------------------------------------

--
-- Table structure for table `accounts`
--

CREATE TABLE IF NOT EXISTS `accounts` (
  `accountId` int(10) unsigned NOT NULL auto_increment,
  `accountUser` varchar(20) NOT NULL,
  `accountPassword` varchar(20) NOT NULL,
  `accountLastLogin` datetime NOT NULL,
  `accountOwner` varchar(100) NOT NULL,
  `accountEmail` varchar(100) NOT NULL,
  `accountOrganization` varchar(50) NOT NULL,
  `accountTelephone` varchar(30) NOT NULL,
  `accountIsAdmin` int(1) NOT NULL,
  PRIMARY KEY  (`accountId`),
  UNIQUE KEY `accountUser` (`accountUser`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;

--
-- Dumping data for table `accounts`
--

INSERT INTO `accounts` (`accountId`, `accountUser`, `accountPassword`, `accountLastLogin`, `accountOwner`, `accountEmail`, `accountOrganization`, `accountTelephone`, `accountIsAdmin`) VALUES
(1, 'admin', 'admin', '2008-07-17 02:22:30', 'Administrator', 'adm@whatever.com', 'Admin Cave', 'xx yyyy.yyyy', 1);

-- --------------------------------------------------------

--
-- Table structure for table `clusters`
--

CREATE TABLE IF NOT EXISTS `clusters` (
  `clusterId` int(10) unsigned NOT NULL auto_increment,
  `clusterName` varchar(50) NOT NULL,
  `clusterIP` varchar(40) NOT NULL,
  `clusterOperationalSystem` varchar(100) NOT NULL,
  `clusterScheduler` varchar(50) NOT NULL,
  `clusterProcessorModel` varchar(30) NOT NULL,
  `clusterNumNode` int(10) unsigned NOT NULL,
  `clusterNumProcessorsPerNode` int(10) unsigned NOT NULL,
  `clusterActive` int(1) NOT NULL,
  `clusterTimestampAlive` datetime NOT NULL,
  `clusterWorkLoad` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`clusterId`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

-- --------------------------------------------------------

--
-- Table structure for table `jobs`
--

CREATE TABLE IF NOT EXISTS `jobs` (
  `jobId` int(10) unsigned NOT NULL auto_increment,
  `projectId` int(10) unsigned NOT NULL,
  `clusterId` int(10) unsigned NOT NULL,
  `jobName` varchar(30) NOT NULL,
  `jobDataFile` longblob NOT NULL,
  `jobStatus` tinyint(4) NOT NULL,
  `jobTimestampCreated` datetime NOT NULL,
  `jobTimestampCaptured` datetime default NULL,
  `jobTimestampEnded` datetime default NULL,
  PRIMARY KEY  (`jobId`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=744 ;

-- --------------------------------------------------------

--
-- Table structure for table `projects`
--

CREATE TABLE IF NOT EXISTS `projects` (
  `projectId` int(10) unsigned NOT NULL auto_increment,
  `accountId` int(10) unsigned NOT NULL,
  `projectName` varchar(50) NOT NULL,
  `projectSourceFile` longblob NOT NULL,
  `projectRequiredProcessors` int(10) unsigned NOT NULL,
  `projectParameters` varchar(50) NOT NULL,
  `projectTimestampCreated` datetime NOT NULL,
  PRIMARY KEY  (`projectId`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=75 ;

-- --------------------------------------------------------

--
-- Table structure for table `results`
--

CREATE TABLE IF NOT EXISTS `results` (
  `jobId` int(10) unsigned NOT NULL,
  `resultOutput` longblob NOT NULL,
  `resultError` longblob NOT NULL,
  UNIQUE KEY `jobId` (`jobId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;